Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Ship-to Name' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to SHIP-TO NAME

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	Ship-to Name
2	1	Company Information	Ship-to Name
3	41	Sales Quote	Ship-to Name
4	42	Sales Order	Ship-to Name
5	43	Sales Invoice	Ship-to Name
6	45	Sales List	Ship-to Name
7	49	Purchase Quote	Ship-to Name
8	50	Purchase Order	Ship-to Name
9	51	Purchase Invoice	Ship-to Name
10	52	Purchase Credit Memo	Ship-to Name
11	53	Purchase List	Ship-to Name
12	88	Job Card	Ship-to Name
13	130	Posted Sales Shipment	Ship-to Name
14	132	Posted Sales Invoice	Ship-to Name
15	134	Posted Sales Credit Memo	Ship-to Name
16	136	Posted Purchase Receipt	Ship-to Name
17	138	Posted Purchase Invoice	Ship-to Name
18	140	Posted Purchase Credit Memo	Ship-to Name
19	142	Posted Sales Shipments	Ship-to Name
20	143	Posted Sales Invoices	Ship-to Name
21	144	Posted Sales Credit Memos	Ship-to Name
22	145	Posted Purchase Receipts	Ship-to Name
23	146	Posted Purchase Invoices	Ship-to Name
24	147	Posted Purchase Credit Memos	Ship-to Name
25	507	Blanket Sales Order	Ship-to Name
26	509	Blanket Purchase Order	Ship-to Name
27	636	IC Outbox Sales Doc.	Ship-to Name
28	638	IC Outbox Purchase Doc.	Ship-to Name
29	640	Handled IC Outbox Sales Doc.	Ship-to Name
30	642	Handled IC Outbox Purch. Doc.	Ship-to Name
31	644	IC Inbox Sales Doc.	Ship-to Name
32	646	IC Inbox Purchase Doc.	Ship-to Name
33	648	Handled IC Inbox Sales Doc.	Ship-to Name
34	650	Handled IC Inbox Purch. Doc.	Ship-to Name
35	5159	Sales Order Archive	Ship-to Name
36	5161	Sales List Archive	Ship-to Name
37	5162	Sales Quote Archive	Ship-to Name
38	5164	Purchase Quote Archive	Ship-to Name
39	5166	Purchase List Archive	Ship-to Name
40	5167	Purchase Order Archive	Ship-to Name
41	5900	Service Order	Ship-to Name
42	5933	Service Invoice	Ship-to Name
43	5935	Service Credit Memo	Ship-to Name
44	5964	Service Quote	Ship-to Name
45	5971	Posted Service Credit Memos	Ship-to Name
46	5972	Posted Service Credit Memo	Ship-to Name
47	5974	Posted Service Shipments	Ship-to Name
48	5975	Posted Service Shipment	Ship-to Name
49	5977	Posted Service Invoices	Ship-to Name
50	5978	Posted Service Invoice	Ship-to Name
51	5980	Service Item Card	Ship-to Name
52	6050	Service Contract	Ship-to Name
53	6051	Service Contract List	Ship-to Name
54	6053	Service Contract Quote	Ship-to Name
55	6065	Customer Service Contracts	Ship-to Name
56	6072	Filed Service Contract	Ship-to Name
57	6620	Blanket Sales Order Archive	Ship-to Name
58	6622	Blanket Sales Order Archives	Ship-to Name
59	6623	Blanket Purchase Order Archive	Ship-to Name
60	6625	Blanket Purch. Order Archives	Ship-to Name
61	6627	Sales Return Order Archive	Ship-to Name
62	6629	Sales Return List Archive	Ship-to Name
63	6630	Sales Return Order	Ship-to Name
64	6640	Purchase Return Order	Ship-to Name
65	6644	Purchase Return Order Archive	Ship-to Name
66	6646	Purchase Return List Archive	Ship-to Name
67	6650	Posted Return Shipment	Ship-to Name
68	6652	Posted Return Shipments	Ship-to Name
69	6660	Posted Return Receipt	Ship-to Name
70	6662	Posted Return Receipts	Ship-to Name
71	9300	Sales Quotes	Ship-to Name
72	9301	Sales Invoice List	Ship-to Name
73	9302	Sales Credit Memos	Ship-to Name
74	9303	Blanket Sales Orders	Ship-to Name
75	9304	Sales Return Order List	Ship-to Name
76	9305	Sales Order List	Ship-to Name
77	9306	Purchase Quotes	Ship-to Name
78	9307	Purchase Order List	Ship-to Name
79	9308	Purchase Invoices	Ship-to Name
80	9309	Purchase Credit Memos	Ship-to Name
81	9310	Blanket Purchase Orders	Ship-to Name
82	9311	Purchase Return Order List	Ship-to Name
83	9321	Service Contracts	Ship-to Name
84	9322	Service Contract Quotes	Ship-to Name
85	9346	Purchase Quote Archives	Ship-to Name
86	9347	Purchase Order Archives	Ship-to Name
87	9348	Sales Quote Archives	Ship-to Name
88	9349	Sales Order Archives	Ship-to Name
89	41002	Hist. Sales Trx. Headers	Ship-to Name
90	41003	Hist. Sales Trx. Lines	Ship-to Name
91	41007	Hist. Sales Trx.	Ship-to Name

Dynamics 365 BC Table ReferencePage Control Search